package com.huiyuanai.pojo.provider;

import com.huiyuanai.dao.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 * @Author: liwan
 * @Description:
 * @Date: create in 2021/10/17
 */
public interface ProviderPojo {
    //查询供应商信息
    List<Provider> getProvider(Connection connection, String proCode, String proName, String id, int beginPage, int endPage) throws SQLException;

    //统计人数
    int getCount(Connection connection, String proCode, String proName) throws SQLException;

    //修改数据
    int upDataProvider(Connection connection, Provider provider) throws SQLException;

    //添加数据
    int addProvider(Connection connection, Provider provider) throws SQLException;

    //删除数据
    int delProvider(Connection connection, String id) throws SQLException;


}
